UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '583Zn6dG0pvyoRiy6kqBDB+k8kfJ7scWgyySDgvZjUI='
WHERE
key_id = 'ae2f244756f1a8f049e3ca6dc4ead47709ec21d3b61601379f1fbaec8d1e27a6'
AND (
token = '583Zn6dG0pvyoRiy6kqBDB+k8kfJ7scWgyySDgvZjUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)