UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9q1+wRPwALk+XZVYu4L5DNkXDtS8G6loVfT0+Dkax78='
WHERE
key_id = 'a018531e3b3fe50752807e0c8fe011106859bd7983cb9a5a61cdcdee280fb57a'
AND (
token = '9q1+wRPwALk+XZVYu4L5DNkXDtS8G6loVfT0+Dkax78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)