UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7fgc3IwSsOIqACgGY8S70CMnfi09O+rmfoVRr3opvpo='
WHERE
key_id = 'c53ab5a703ad8e0e05cc6b7cc3d31e96b04bfc26e4b48721a72af315de053000'
AND (
token = '7fgc3IwSsOIqACgGY8S70CMnfi09O+rmfoVRr3opvpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)