UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sVp5ixN70POHax9T3yUahUG+gcPXW0Y3HRpBq+kv7ws='
WHERE
key_id = 'b0780cfa18bee7b5786f23ba0b95292ca3e855dcb983c1d683157d057217412e'
AND (
token = 'sVp5ixN70POHax9T3yUahUG+gcPXW0Y3HRpBq+kv7ws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)