UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '63GzjwFmo4MiAhMogDYH+A3fdpM3ak+zYzq5Qg3YebU='
WHERE
key_id = 'b9f13cc246ce4b36d32512aa9990624a3d3af7abf9168a714ef03a94fb4f4a74'
AND (
token = '63GzjwFmo4MiAhMogDYH+A3fdpM3ak+zYzq5Qg3YebU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)