UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsrakvbQb5HUUrYntEHlFqwqMVjDS2WRdh94jY6AfVI='
WHERE
key_id = '31d5cf8847c6733f34ac6cd47939f06c42d0ab3d95be73ee54b4be495f7a166b'
AND (
token = 'QsrakvbQb5HUUrYntEHlFqwqMVjDS2WRdh94jY6AfVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)