UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWp/aDBg6Hc9jnrRp32UcRc1rgsM94eL5V3bvQoNzwE='
WHERE
key_id = 'c01417adb6c55180bb7d9aa0534d0d78e8b731f5f186d92de2610d30277d13ab'
AND (
token = 'bWp/aDBg6Hc9jnrRp32UcRc1rgsM94eL5V3bvQoNzwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)