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