UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hmMk7jAaLz4j+7ldFqH5akuFUc6ecYdCi4t3zw7BPmg=' 
WHERE 
  key_id = 'dc5c79e161b6d01bea211badcd1b5b54f7384e22b3b3e0ea2ecd27ee9f5785a9' 
  AND (
    token = 'hmMk7jAaLz4j+7ldFqH5akuFUc6ecYdCi4t3zw7BPmg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022