UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whmSixcJC6pIMxXuGu7UmfoFXfAGjCjzDV6OtB0vdv8='
WHERE
key_id = 'ccadb470cf687a2d3539f903991e8773ac11ec07a77029efa6b04589fc9df6d2'
AND (
token = 'whmSixcJC6pIMxXuGu7UmfoFXfAGjCjzDV6OtB0vdv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)