UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6z4pI7UswcrD6xtuj4ptmFcJPDr5Io4QjLofKxgerI='
WHERE
key_id = '1980cb6cacb6d72bf54b34a8b15205686a466840acc704bc449cf03b6b99a659'
AND (
token = 'a6z4pI7UswcrD6xtuj4ptmFcJPDr5Io4QjLofKxgerI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)