UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O0ioW4AEFnsYP8cMxH+jU7V96CdkI+IP0QNViVa1UMY='
WHERE
key_id = 'f6018a3441ceae0b79b4161e7c78f8f67d58b477a51223a818d387d22a09c00a'
AND (
token = 'O0ioW4AEFnsYP8cMxH+jU7V96CdkI+IP0QNViVa1UMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)