UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mriYj6RQ7gsAKiK7D/N6vs82LjeIu0Vd/r0rWljZY0A='
WHERE
key_id = '65e5191179eea10c3bf007a94dc655aec3b966abd91cc1f89be7daf5cb094de7'
AND (
token = 'mriYj6RQ7gsAKiK7D/N6vs82LjeIu0Vd/r0rWljZY0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)