UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2o0biBOTC2fM7/rX8s9EPWNEa3zpIS7v3GqBiPe/acM='
WHERE
key_id = '1a4ee67195ff00d9722cd1db39eb9d223a9d5682fc08b913d0c855adf81fcbb2'
AND (
token = '2o0biBOTC2fM7/rX8s9EPWNEa3zpIS7v3GqBiPe/acM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)