UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwJwA8XOl0wUiETIGiAGkx1RCfjOVZ2ngX7Rdc+1th4='
WHERE
key_id = '6a4c18d9c35b8cb47d8778a38886f6d082161df66d00c07200a517a997edbe36'
AND (
token = 'qwJwA8XOl0wUiETIGiAGkx1RCfjOVZ2ngX7Rdc+1th4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)