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