UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd+6Sihl0CrYxDsMqmghEqtnDahS/itA5y3uail7jK9g='
WHERE
key_id = 'c02e31b23c0ed459b8ce254010be73a768b0cf3d931e7845cbb227631ba71c73'
AND (
token = 'd+6Sihl0CrYxDsMqmghEqtnDahS/itA5y3uail7jK9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)