UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqZEk6QkZc5JQoRl6+yB7zVxe15hgS++kxkuMJ8AZgI='
WHERE
key_id = '8b0f1616072385d510d81cc728f435049c564a1343ff110e186bc358b7b04229'
AND (
token = 'XqZEk6QkZc5JQoRl6+yB7zVxe15hgS++kxkuMJ8AZgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)