UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XThArL/kFdNGm7OAW9Nywo/4oj3Xsg7S/LMKvsJTiu0='
WHERE
key_id = 'e3052239c59e0e4efa40938ee2768015ef4def45fd4c815be2da5f61a4b5cec3'
AND (
token = 'XThArL/kFdNGm7OAW9Nywo/4oj3Xsg7S/LMKvsJTiu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)