UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnYEO0UOso9djqq1iVolazft2NOyNu+DErKfN0gCxX4='
WHERE
key_id = 'd7e4bbb1efe9fae854d3ed6a9424ed0b729c7467cb33401787e4dea1de42da05'
AND (
token = 'ZnYEO0UOso9djqq1iVolazft2NOyNu+DErKfN0gCxX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)