UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQ2a/8uKEIj4SU4vtxjxhZrWOc83iRRINl/eRra8tiA='
WHERE
key_id = 'ff67fba5281ad679f6dfdd6d3fb1042b22af03a66b0c8bd3531c29a49868d4a4'
AND (
token = 'dQ2a/8uKEIj4SU4vtxjxhZrWOc83iRRINl/eRra8tiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)