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