UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XaG93YLhQZEc4XuC9wWqTJTtKYuTKjqR8YKUDpW5aZg='
WHERE
key_id = '201a77b214cb5fef10f5f4f5375eb870d8099ce3193e500f615ee13ca1cbc129'
AND (
token = 'XaG93YLhQZEc4XuC9wWqTJTtKYuTKjqR8YKUDpW5aZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)