UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J5qPAF5gt9TgAdqFvY4sMB+3TVeQ442bUSV4CHwV6Bk='
WHERE
key_id = '8f7ea031e3fdb359628a5179ed4b3dea7a80bb254936559e99da998adebbd390'
AND (
token = 'J5qPAF5gt9TgAdqFvY4sMB+3TVeQ442bUSV4CHwV6Bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)