UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ug0VIvQwUls8cB30tN92Y5bv5BS6PSGvkFCdC/aFhCc='
WHERE
key_id = '5ad931f134bd5c8bf924a6a7d23817f0113eb0267afb417578c1455c5064130f'
AND (
token = 'ug0VIvQwUls8cB30tN92Y5bv5BS6PSGvkFCdC/aFhCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)