UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LAvQhvAXLk5fpYb5BTSjNqUoB8YkB3k4vxOAoYQzuAc='
WHERE
key_id = 'b859fb6dc0d1e236cdb4829f8b3e7f829cd9f5a234107506b935c657932ee91b'
AND (
token = 'LAvQhvAXLk5fpYb5BTSjNqUoB8YkB3k4vxOAoYQzuAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)