UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B12wGW1gic8M3GybQKRJaFd+UJJkRGDKIzWiYJG9Gdw='
WHERE
key_id = '3e55cfa76d6622e7c340e50ba69bef6d70582f3065c33a09f935283bacef9cba'
AND (
token = 'B12wGW1gic8M3GybQKRJaFd+UJJkRGDKIzWiYJG9Gdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)