UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUIOcYepKG3PeUphwFVwD8mPur3EgzaPqW7U1HfnMhE='
WHERE
key_id = 'c3cf086bf8d40af82a572bd26842add5fae5c17c11357f3df75e5a88828a9f11'
AND (
token = 'HUIOcYepKG3PeUphwFVwD8mPur3EgzaPqW7U1HfnMhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)