UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtI9kIWJXO3nAPfBzJop1zuKcStOLGN+BORn7w3jUVA='
WHERE
key_id = '8be7e7ec27ca5e335292ad6b7b3636d6e1e4ad548b85d466510e61bc05011a47'
AND (
token = 'HtI9kIWJXO3nAPfBzJop1zuKcStOLGN+BORn7w3jUVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)