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