UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9Xb8yMlUlF6emYQwKopktX4ZC6f5Jt25I046WHeeCY='
WHERE
key_id = '0fe3d5ca585c3566c7a3ab80b62f06610d1c48f938dd9e514423ee808b43c557'
AND (
token = 'J9Xb8yMlUlF6emYQwKopktX4ZC6f5Jt25I046WHeeCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)